Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$PQ_SESSTAT

This view lists session statistics for parallel queries. After you have run a query or DML operation, you can use the information derived from `V$PQ_SESSTAT` to view the number of slave processes used, and other information for the session and system.

Column | Datatype | Description
--- | --- | ---
`STATISTIC` | `VARCHAR2(30)` | Name of the statistic: `Queries Parallelized` - Number of queries run in parallel `DDL Parallelized` - Number of DDL operations run in parallel `DML Parallelized` - Number of DML operations run in parallel `DFO Trees` - Number of executed DFO trees `Server Threads` - Number of PX servers used `Allocation Height` - Requested number of servers per instance `Allocation Width` - Requested number of instances `Local Msgs Sent` - Number of local (intra-instance) messages sent `Distr Msgs Sent` - Number of remote (inter-instance) messages sent `Local Msgs Recv'd` - Number of local (intra-instance) messages received `Distr Msgs Recv'd` - Number of remote (inter-instance) messages received
`LAST_QUERY` | `NUMBER` | Value of the statistic for the last operation
`SESSION_TOTAL` | `NUMBER` | Value of the statistic for the entire session to this point in time